AD 56-01-01
Registered aircraft · 152
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:56-01-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:56-01-01')
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:56-01-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:56-01-01') 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.
N100HTMitchell Brian N · Scottsdale, AZN10175Bassett Donald J · Midland City, ALN101MFUsda Forest Service Fepp · Trenton, NJN1023VPeterson Chester L · Willis, TXN10BUKitzmiller Douglas A · Punta Gorda, FLN10RNExecutive Jet A LLC · Danbury, CTN1101VClement Walter F · Enfield, NCN12220Dixon Craig S · Rimrock, AZN125MRBlue Ridge Helicopters LLC · Martinsville, VAN130VJ Bird Air Service LLC · Cheyenne, WYN13298Lidija LLC · Grass Valley, CAN13ASScholem Paul F · Rutherfordton, NCN147CGMagic Carpet Ride Aviation LLC · Columbus, OHN147DPWeeks Kermit A · Polk City, FLN147SMMazar Stephen M · Flushing, MIN15395Magnum Aviation LLC · Goff, KSN155JNAero-Mobil Inc · Wilmington, DEN17611Tc Bouslog LLC · Noblesville, INN1773Aircraft Sales LLC · Caledonia, MIN17SSDodson Larry A · Lone Oak, TXN18807Swing Wing Inc · Veedersburg, INN200KVPeavy Magnus Delacy IV · Crawfordville, FLN210BL & L Delivery Ltd · Romulus, MIN2199Heritage Flight Museum · Burlington, WAN2292BMy Way LLC · Missoula, MTN22APGospel Ministries International Inc · Collegedale, TNN22SHBryan Robert C · Waller, TXN24067Pearce Michael J · Phoenix, AZN2469BKothman Kenn Kode · Sheffield, TXN2473BKerr Douglas E · Oakland, CAN2490BExperimental Acft Assoc Inc · Oshkosh, WIN2507X4 Star Aviation Inc · Jefferson City, MON250894 Star Aviation Inc · Jefferson City, MON2508K4 Star Aviation Inc · Jefferson City, MON2509F4 Star Aviation Inc · Jefferson City, MON262MVCavanaugh Charters Inc · Addison, TXN2795AMiles Flying Service Inc · Bono, ARN2801BTaz Air Service Inc · Middletown, DEN2802BN2802b LLC · Crestview, FLN2806BHeliflight Leasing LLC · Bulverde, TXN2807BSuess Robert D · San Jose, CAN2814BC-Fleet LLC · Missoula, MTN2817BNew Air Inc · Pocahontas, IAN2821BLumley William B · Delray Beach, FLN2822BEnglish Air Service LLC · Georgetown, TXN2823BGulf Helicopters LLC · Santa Fe, TXN2862BGraulich David A · Sharon Springs, NYN2870BBell Homer K · Hillsboro, OHN2899BClassic Rotors Museum · Ramona, CAN29GRMagnum Aviation LLC · Goff, KS
Back to AD 56-01-01