AD 81-18-04 R2
Registered aircraft · 81,733
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N6212GLionheart Aviation Services LLC · Fairfax, VAN6212PJobin Lyle S · Madeira Beach, FLN6212RPliego M Guillermo M · Corpus Christi, TXN6212UEwart Douglas G · Kansas City, MON6212WSoto Miguel · Windcrest, TXN6212ZBorszich Claude C Jr · Phoenix, AZN6213Jenkins Susan · Pima, AZN62136Gist Sally R · Horseshoe Bay, TXN6213UVan Zyll De Jong Sean M · Keenesburg, COFirst renewal noticeN6213WDunn William R · Indio, CAN62142Xin Han Aviation LLC · Atwater, CAN62147Stevens James A Jr · Morganton, NCN6214JSale Reported · Mikado, MISale reportedN6215YBraden Gale E · Edmond, OKN6216JThibeault Barbara C Horne · Eagan, MNN6216NHitt Kenneth A · Driftwood, TXN6216PDuvall James Grafton III · Silver Springs, NVN6216RRegistered aircraftN6216XCentral Alabama Soaring Association · Birmingham, ALN6217CButler Donald D · Petersburg, PAN6217HWalker Robert J · Manvel, TXN6217JNathaniel Greene Dev Corp · Stanardsville, VAFirst renewal noticeN6217NXing Kong Aviation Service LLC · Atwater, CAN6217PYork Robert H · Zephyr Cove, NVN6217QZulu Kilo LLC · Seven Valleys, PAN6218BBrant Air LLC · Davidsonville, MDN6218JNelson Jeffery M · Eagle River, AKN6218PSmith Ron E · Goodlettsville, TNN6218QOzarks Auto Show Inc · Hollister, MON6218UEkstrum Eric · Mound House, NVN6218ZLorenzo Ag Air Inc DBA · Lorenzo, TXN62199Aircraft Guaranty Corp Trustee · Oklahoma City, OKN6219AVann Dudley C · Greenville, NCN6219LBradley Jason · Fort Mohave, AZN621AAWings Over Texas Holdings LLC · Denton, TXN621ACFlorida Institute Of Technology Inc · Melbourne, FLN621BAWilliams Travis D · Antlers, OKN621BDYeagle James A · Atlanta, GAN621BFBoldflight LLC · Danville, INN621BSStauter Mike D · Idabel, OKN621CLN621cl LLC · Overland Park, KSN621DCResource Extension LLC · Jupiter, FLN621DHPic Aviation LLC · Fort Valley, GAN621EHofstetter Michael T · Saint James, MON621FJ8th Dimension Enterprises LLC · Aurora, ORN621FLKiani Behdad · Elk Grove, CAN621FTFlorida Institute Of Technology · Melbourne, FLN621GLOverwatch Tools Inc · Chesapeake, VAN621HDyer John T · Whispering Pines, NCN621HSBlue Skies Flying Services Inc · Lake In The Hills, IL
Back to AD 81-18-04 R2