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.
N734UTBlue Sky Aviation LLC · Menominee, MIN734UUPenn Aero LLC · Lewisburg, PAN734UVCavu Flying Club · Wauwatosa, WIN734UWFisher Stephen C Trustee · Lamar, ARN734UXJantz Carl R · Columbia, MON734UYAg & Csv Inc · Pine Bush, NYN734UZDream Unthreatened LLC · San Luis Obispo, CAN734VCNashville Skyscrapers LLC · Old Hickory, TNN734VEFlyby Aviation LLC · Logan, UTN734VNKcsi Aerial Patrol Inc · Bakersfield, CAN734VPBooth Danielle M · Somis, CAN734VQJprg Aviation Inc · Orlando, FLN734VTDestination Aviation LLC · Destin, FLN734VVSummit Flight Services LLC · Paden, OKN734VXRed Door Aviation LLC · Dover, DEN734VZTri Air Inc · Aulander, NCN734WBWedoaero LLC · Vale, NCN734WFLewis Patrick K · El Dorado, ARN734WKWagner James M · Hockessin, DEN734WNBoerne Flight Options LLC · Boerne, TXN734WPLaps LLC · Elkhorn, WIN734WRSealy Michael Robert · Summerville, SCN734WSWingsleasing LLC · Wichita, KSN734WZTingman Christopher · Seattle, WAN734XMahler Steven · Hanover, PAN734XCCurrier William R · Ormond Beach, FLN734XDByrne David · Three Rivers, MIN734XKEllig Todd L · Horace, NDN734XLWalsh Patrick Sean · Osterville, MAN734XMTri Star Cac LLC · Plano, TXN734XPDutcher John A · Cedar Falls, IAN734XQSumter County Sheriffs Office · Sumter, SCN734XSCrabtree Clifford I · Ukiah, CAN734XTFlying Colors Airparts Inc · Leesburg, FLN734XXHuerta Holdings Inc · Santa Ana, CAN734XYBend Aircraft Mechanics LLC · Bend, ORN734YALuxair LLC · College Station, TXN734YBHrbk LLC · Grandview, INN734YCShaw Terry R · Olympia, WAN734YDWings Over Texas Holdings LLC · Denton, TXN734YLTactical Integrated Training Solutions LLC · San Antonio, TXN734YMStockbridge Valley Flying Club Inc · Syracuse, NYN734YVHarvey David C · Wellsboro, PAN734YXKvalita John C Jr · Port Charlotte, FLN734ZAHanson Brian · Sauk City, WIN734ZCGeorges Aviation Services Inc · Honolulu, HIN734ZGHorn Norman R · Las Vegas, NVN734ZKDockins Jamie · Athol, IDN734ZQMidway Flying Club Inc · Attleboro, MAN734ZTWatauga Eagle Squadron Foundation · Elizabethton, TN
Back to AD 81-18-04 R2