AD 2000-06-01
Registered aircraft · 39,302
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:2000-06-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:2000-06-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:2000-06-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:2000-06-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.
N1110FSallade William L · Coudersport, PAN1110SMob Aviation USA LLC · Kissimmee, FLN11115Crist Steve · Reno, NVN11126Laird Charles L · Adelanto, CAN11128Fletcher Jason · Camden, ARN11131Gaglioti John · Monterey, CAN11133Hanus David S · Mound, MNN11135Wicks Floyd · Laurelville, OHN11138Wen Su Ephraim · Fullerton, CAN11139Olson Philip D · Garden Plain, KSN11142Galion Air Inc · Galion, OHN11144Hawkins Larue S · Carrollton, MON11145Martin Walter J · Ocala, FLN11146Williams Ryan C · East Helena, MTN11149Schmitt Rudy · Brookshire, TXN1114FRegistration Pending · Florence, SCRegistration pendingN1114TQuellette James L · Plymouth, CTN11156Mayer Randal J · Argusville, NDN11157Patel Rahul G · Austin, TXN1115UAvian Leasing LLC · Bremerton, WAN11169Cooper Donald L Jr · El Granada, CAN11172Skaaire Society · Madison, WIN11173Miller William L Jr · Corinth, MSN11179Holloway David · Auburn, CAN1117THimes Austin M · Wentworth, MON1117UBhp Aviation · Santa Clara, CAN11182Smith Brian · Roanoke, TXN11183Stancil James T · Jasper, GAN11185Stancil Joe E Jr · Eagle River, AKN11186Round Engine Aero · Nashville, MIN11196Clark Joseph C · Avondale, PAN111ATSkymaster Stc LLC · Mena, ARN111BLLandry Patrick Todd · Georgetown, TXFirst renewal noticeN111CAce'S Hangar LLC · Bentonville, ARN111CJRegan Dennis W · Rochester, MNFirst renewal noticeN111CYSmody Michael S · Neelyville, MON111DEPespisa John · Hacienda Heights, CAN111EXNew Orleans Aviation LLC · Covington, LAN111EYHook Steven · Pasco, WAN111FFGutierrez Isaias · Fontana, CAN111GN111g LLC · Longmont, CON111GFHuggins Stephen M · Eagle Creek, ORN111HCBennett Miranda Mathis · Fairhope, ALN111HPFlying Aces Aero-Fleet Inc · Guyton, GAN111HSMacav Flight Training LLC · Abilene, TXN111HVBga-Viation · Bennettsville, SCN111KBSale Reported · Mexico D FSale reportedN111LHSuperior Aviation Gateway LLC · Tampa, FLN111NJNew Jersey Forest Fire Service · Trenton, NJN111PWKilgore Eric M · Genoa, NV
Back to AD 2000-06-01