Registered aircraft · 629

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

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:90-07-10-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-07-10-R1') ORDER BY n_number

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:90-07-10-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-07-10-R1')
  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:90-07-10-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-07-10-R1')
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.

N555HMAirops II LLC · Salinas, CABuilt 2000 · S/N 550-0950 N555RTSct Aviation LLC · Fort Lauderdale, FLBuilt 1981 · S/N 5510323 N556MWN970aj LLC · Evans, COBuilt 2003 · S/N 550-1074 N557CSRabbit Hill Industries Inc · Bedford, NYBuilt 1984 · S/N S550-0016 N558CGCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1990 · S/N 5500664 N559WJWanger Jones Helsley Pc · Fresno, CABuilt 2000 · S/N 550-0909 N55LXWoodbine Aviation LLC · Lewes, DES/N 550-0366 N55WLLatshaw Sonja M · Vero Beach, FLBuilt 1980 · S/N 550-0140 N560JAJjl Aviation LLC · Springville, IABuilt 1998 · S/N 550-0849 N562RMMas Aircraft Leasing LLC · Missoula, MTBuilt 1990 · S/N 550-0646 N565ARAr Aviation Group LLC · Springfield, ORBuilt 2000 · S/N 550-0919 N565GGN1130j LLC · Huntsville, TXBuilt 1990 · S/N 5500643 N568PCW Carl Reynolds Pc · Macon, GABuilt 1984 · S/N 551-0500 N568STRegistered aircraftBuilt 1987 · S/N 550-0565 N569CCRebel Aircraft LLC · Rapid City, SDBuilt 2005 · S/N 550-1113 N573MBohlke LLC · Kingshill, VIBuilt 2003 · S/N 550-1066 N575MGAntelope Valley Community College District · Lancaster, CAS/N 550-0450 N575SGOsage Aviation LLC · Yates Center, KSBuilt 1985 · S/N S550-0064 N577BBB And K Aircraft Holdings LLC · North Canton, OHBuilt 1997 · S/N 550-0826 N577MCUltraa Air LLC · Lafayette, CABuilt 1998 · S/N 550-0861 N578GGN578gg LLC · Amarillo, TXBuilt 1985 · S/N S550-0079 N579MJet Air Inc · Galesburg, ILBuilt 2006 · S/N 550-1133 N57BJPlukair Delaware LLC · Wilmington, DES/N S550-0052 N584PSGilco Enterprises LLC · Benbrook, TXBuilt 1998 · S/N 550-0847 N5852KBode Aviation Inc · Albuquerque, NMBuilt 2003 · S/N 550-1056 N585KSSaai.Com LLC · Miami, FLBuilt 2000 · S/N 550-0945 N585KTSadler Trevor Trustee · ProvidencialesNon-citizen corporation, flight hours not reportedS/N 550-0420 N588ACBlu Bird Consulting Services LLC · Burnet, TXBuilt 2000 · S/N 550-0912 N588FPJk Aircraft Options LLC · Aripeka, FLS/N 550-0228 N588JKJk Aircraft Options LLC · Saint Petersburg, FLBuilt 1988 · S/N 550-0570 N589FPJk Aircraft Options LLC · Aripeka, FLBuilt 1981 · S/N 550-0337 N589HHAccelgf Inc · Reno, NVBuilt 2002 · S/N 550-1005 N591FPJk Aircraft Options LLC · Aripeka, FLBuilt 1981 · S/N 551-0304 N592FPJk Aircraft Options LLC · Aripeka, FLBuilt 2001 · S/N 550-0974 N593FPJk Aircraft Options LLC · Hernando Beach, FLBuilt 2002 · S/N 550-1010 N594FPJk Aircraft Options LLC · Hernando Beach, FLBuilt 2001 · S/N 550-1004 N594WPGolden Leaf Tobacco Company Inc · Keysville, VABuilt 1992 · S/N 550-0693 N595RMAntelope Valley Community College District · Lancaster, CABuilt 1979 · S/N 550-0061 N598KWRegistered aircraftS/N S550-0098 N59GBTh Leasing Corp · Wilmington, DEBuilt 1982 · S/N 551-0060 N5TRN535j LLC · Bismarck, NDBuilt 1981 · S/N 551-0351 N600ATHarlow Cattle LLC · Dallas, TXBuilt 1987 · S/N 550-0551 N600EAEstancia Aviation LLC · Reno, NVBuilt 1985 · S/N S5500015 N600HWSafe Adventures LLC · North Miami, FLBuilt 1983 · S/N 5500479 N600TBFleet Aircorp Inc · Fort Lauderdale, FLS/N 550-0154 N601BCAir Prive Solutions LLC · Miami Beach, FLBuilt 1979 · S/N 550-0091 N601CBCj1 LLC · Carmel, INBuilt 2002 · S/N 550-1014 N602ATOdl Partners LLC · Oklahoma City, OKS/N 550-0606 N603DWOnarco2 LLC · Maurice, IABuilt 2005 · S/N 550-1109 N604PJJere Aviation LLC · Fond Du Lac, WIBuilt 1983 · S/N 550-0459

Back to AD 90-07-10 R1